SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:What a gem situated within the big little city of Lebanon, NH. Built during the Eastlake Architectural movement in 1860 this Victorian home has all the features one expects to see for the time period including ornate floral carvings that adorn the exterior. Tastefully updated by the few owners who have appreciated her history, this home provides ample space for cohabitation of one or more generations of occupants. Off the rear of the home, where you will find ample parking, is a separate entrance that could be used as a home based office complete with kitchenette and bathroom. It can even serve as quarters for an in home assistant to the residents or good friend or family member. From the front or side covered porch you enter the main home and appreciate the history that flows from its rooms. Two options for a first floor bedroom are available for those who desire or need single level living. A three season sunroom on the second floor could function as a game room, exercise space or a space to entertain or hang 10; the possibilities abound. Combine this with ample sized sleeping rooms including an impressive primary suite, the second floor fosters a feeling of home with its comfort and warmth. The basement would make for an impressive home based gym essential for the winter months when we feel somewhat trapped by the weather or perhaps even a daycare as I understand it once was. Walking distance to the Marsh Brothers Deli, Lucky's Coffee House, Village Pizzeria, Salthill Irish pub, Three Tomatoes Italian Restaurant and Lebanon Opera House means the property is near the Lebanon Green famous for its outdoor concerts, farmers markets and festivals. Perhaps you're interested in an investment property vs. a single family dwelling? This home and layout provides many opportunities.
Description:Set on over 76 private acres, this Cape Cod style home offers the perfect blend of comfort, practicality, and direct access to the outdoors. The home features four bedrooms and three bathrooms, including a generous primary suite with an ensuite bath. The open-concept kitchen, dining, and living areas create a welcoming space for everyday living and entertaining. A mudroom with a new pellet stove adds warmth and utility, while a full basement and large detached garage provide ample room for storage, including all your outdoor gear. Take in sweeping, unobstructed views of Smarts Mountain from the inviting farmers porch, an ideal spot to relax after a day spent exploring. This is truly a private outdoor retreat. A two-mile trail winds through the property, perfect for cross-country skiing, snowshoeing, or mountain biking. Make your own maple syrup in the super comfortable sugar shack. Tucked into the woods, a treehouse offers a charming escape for kids or adults alike. Beyond the property, find easy access to the Green Woodlands, home to miles of perfectly groomed cross-country skiing and mountain bike trails, as well as the Appalachian Trail and Dartmouth Skiway. Just 15 minutes to the center of Lyme and under 30 minutes to Hanover, this is a rare opportunity to own a spacious, private property in a truly exceptional location. A dream for outdoor enthusiasts and anyone seeking space, and year-round adventure.
Description:Spacious, move-in-ready, contemporary home with 3 bedrooms plus a bonus room, 4.5 baths and over 3,000 SF. Ideally situated on 2+ acres with privacy and views of the meadow and pond. Property abuts Grantham Recreational Park and conservation land. You’ll absolutely love the state-of-the-art kitchen featuring granite countertops, a large island, walk-in pantry, professional-grade gas range, custom tile backsplash, and two dishwashers. The open layout flows into a dining area and continues to an expansive living room with vaulted ceilings and a beautiful fireplace as the focal point. The first-floor primary suite offers a generous walk-in closet and two separate baths for convenience. Two more bedrooms, each with its own bath, and a bonus room are on the lower level. You'll also find a family room filled with natural light in the walkout lower level. Additional highlights include a home office, whole-house generator, direct entry from the 2-car garage, a screened porch, and large wraparound deck. Located just minutes from I-89, this property provides easy access to the Upper Valley and Dartmouth-Lake Sunapee Region. The area offers year-round opportunities for outdoor recreation including kayaking, fishing, skiing, ice skating, and more. All this in a lovely country setting.
Description:This 3 bed, 3 bath home is perfectly situated in the desirable Fieldstone Ridge neighborhood with views to Cardigan Mountain. You will fall in love with the light filled, open concept spaces including a wonderful sunroom with seasonal views of the Whaleback ski area ridge line. Enjoy the ease of one level living with a primary suite with a double sided propane fireplace, beautifully renovated 3/4 bath and a large walk-in closet as well as a designated laundry space all conveniently located on the main level. Upstairs there are 2 oversized bedrooms and a full bath. Still need more space? The full walk out basement is unfinished but has endless possibilities to add more living space, an office, exercise area and workshop. Bring your ideas and join this lovely community. Neighbors gather for hikes, snow shoeing and annual parties if you wish. Otherwise keep to yourself and enjoy the easy accessibility to downtown Lebanon, Dartmouth Health within 15 mins and Hanover just under 20 minutes away. The perfect spot to enjoy the Upper Valley lifestyle. Showings begin on Friday 3/27 at the Open House from 12-2. Saturday Open House 10-12.
Description:This West Lebanon gem combines classic comfort with a versatile, modern layout. At the heart of the home, a bright eat-in kitchen with a large island flows naturally into a spacious living room anchored by a cozy fireplace. The second floor offers four bedrooms, including a primary suite with a private bath. For added flexibility, a separate suite above the two-car garage features a kitchenette and built-ins—perfect for guests, a home office, or recreation. Outside, enjoy the quiet neighborhood from the deck or the level, tree-lined backyard. Ideally located, you’re just a quick bike ride from Hanover’s Main Street with easy Advance Transit access to the rest of the Upper Valley. Showings to begin at the Open House on Sunday, March 29th from 1pm to 3pm.
Description:Charming 4-bedroom, 3-bath farmhouse nestled on over 4 acres of open pasture and field. This inviting home blends classic character with modern updates, featuring beautiful hardwood floors, an updated kitchen with plenty of space for cooking and gathering, and comfortable living areas filled with natural light. The additional finished space over the garage offers flexibility for a guest suite, office, or recreation room. Enjoy peaceful local mountain views from the screened in porch or spend evenings by the outdoor firepit, perfect for entertaining or relaxing under the stars. With easy access to town, schools, and all amenities, this property combines the serenity of country living with everyday convenience and plenty of blueberries with over 40 bushes to pick from. Ideal for those seeking room to roam, a place for animals or gardens, and a home designed for comfort and connection. Just minutes from I89, Lebanon green and DHMC plus part of this 4 acres has direct access to the rail trail for walking and biking. Open House Saturday March 28th from 11:30-1:00pm
Description:50 Acres. 3 miles to Dartmouth Medical Center. Walk to downtown, school, or airport shuttle. 8 Acres zoned Light Industrial. 1400 sf house in very good condition with attached 2 car garage and separate barn/storage. All within a 3-acre development envelope set back for full privacy. The additional 47 acres are sloping and wooded. Added value from extra privacy for an in-town location, and timber resources. Rare in town house with commercial development potential with 50 acres! Possible subdivision. Enjoy in town and private living, hold for the pending rezoning to General Commercial land or redevelop under the current zoning. Due to delayed zoning the owner drastically reduced for quick sale. Here is your opportunity for high demand, low supply commercial land near College and Medical Center at a residential land price. Retail services and recreational amenities nearby. (Montcalm golf, Whaleback ski center, Mascoma Lake.)